<?php
require_once dirname(__FILE__) . '/../includes/common.inc.php';
require_once dirname(__FILE__) . '/../includes/pdoorm.inc.php';

header('Content-Type: text/plain');

$sql="
CREATE TABLE `ns_v1purchaseitem` (
  `e_oid` int(12) NOT NULL AUTO_INCREMENT,
  `trackId` varchar(64) DEFAULT NULL,
  `cancelled` tinyint(1) DEFAULT NULL,
  `sampleId` int(11) DEFAULT NULL,
  `name` varchar(64) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `unit` varchar(64) DEFAULT NULL,
  `type` varchar(64) DEFAULT NULL,
  `model` varchar(64) DEFAULT NULL,
  `otherId` varchar(64) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  `packageInc` varchar(64) DEFAULT NULL,
  `isFree` tinyint(1) DEFAULT NULL,
  `urgent` tinyint(1) DEFAULT NULL,
  `order_id` int(12) NOT NULL COMMENT'myorder编号',
  PRIMARY KEY (`e_oid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1
";

sql_execute($sql);
